import com.zywl.utils.utils.MSExcelUtil;
import org.junit.Test;

import java.util.ArrayList;
import java.util.List;

public class Text {

    @Test
    public void eee(){
        try {
            String url = "C:\\Users\\Administrator\\Desktop\\3333.xlsx";
            List<List<String>> list = MSExcelUtil.getXlsTextByFullFilePath(url, 0, 2);
            if (list != null && !list.isEmpty()) {
                int total = list.size();
                List<String> lineData = null;
                String isbn,sita;
                for (int i = 1; i < total; i++) {
                    lineData = list.get(i);
                    isbn = lineData.get(0);
                    sita = lineData.get(1);
                    System.out.println("update dbt_order_supplies1 set volume_unit = '"+sita+"' where id = '"+isbn+"';");
                }
            }
        }catch (Exception e){
            e.printStackTrace();
        }
    }
}
